package com.zhongwang.mms.gen.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class PInventoryExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PInventoryExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andItyIdIsNull() {
            addCriterion("ity_id is null");
            return (Criteria) this;
        }

        public Criteria andItyIdIsNotNull() {
            addCriterion("ity_id is not null");
            return (Criteria) this;
        }

        public Criteria andItyIdEqualTo(Integer value) {
            addCriterion("ity_id =", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdNotEqualTo(Integer value) {
            addCriterion("ity_id <>", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdGreaterThan(Integer value) {
            addCriterion("ity_id >", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_id >=", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdLessThan(Integer value) {
            addCriterion("ity_id <", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdLessThanOrEqualTo(Integer value) {
            addCriterion("ity_id <=", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdIn(List<Integer> values) {
            addCriterion("ity_id in", values, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdNotIn(List<Integer> values) {
            addCriterion("ity_id not in", values, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdBetween(Integer value1, Integer value2) {
            addCriterion("ity_id between", value1, value2, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_id not between", value1, value2, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeIsNull() {
            addCriterion("ity_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeIsNotNull() {
            addCriterion("ity_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeEqualTo(String value) {
            addCriterion("ity_mat_code =", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeNotEqualTo(String value) {
            addCriterion("ity_mat_code <>", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeGreaterThan(String value) {
            addCriterion("ity_mat_code >", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_mat_code >=", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeLessThan(String value) {
            addCriterion("ity_mat_code <", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_mat_code <=", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeLike(String value) {
            addCriterion("ity_mat_code like", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeNotLike(String value) {
            addCriterion("ity_mat_code not like", value, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeIn(List<String> values) {
            addCriterion("ity_mat_code in", values, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeNotIn(List<String> values) {
            addCriterion("ity_mat_code not in", values, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeBetween(String value1, String value2) {
            addCriterion("ity_mat_code between", value1, value2, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatCodeNotBetween(String value1, String value2) {
            addCriterion("ity_mat_code not between", value1, value2, "ityMatCode");
            return (Criteria) this;
        }

        public Criteria andItyMatDescIsNull() {
            addCriterion("ity_mat_desc is null");
            return (Criteria) this;
        }

        public Criteria andItyMatDescIsNotNull() {
            addCriterion("ity_mat_desc is not null");
            return (Criteria) this;
        }

        public Criteria andItyMatDescEqualTo(String value) {
            addCriterion("ity_mat_desc =", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescNotEqualTo(String value) {
            addCriterion("ity_mat_desc <>", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescGreaterThan(String value) {
            addCriterion("ity_mat_desc >", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescGreaterThanOrEqualTo(String value) {
            addCriterion("ity_mat_desc >=", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescLessThan(String value) {
            addCriterion("ity_mat_desc <", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescLessThanOrEqualTo(String value) {
            addCriterion("ity_mat_desc <=", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescLike(String value) {
            addCriterion("ity_mat_desc like", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescNotLike(String value) {
            addCriterion("ity_mat_desc not like", value, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescIn(List<String> values) {
            addCriterion("ity_mat_desc in", values, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescNotIn(List<String> values) {
            addCriterion("ity_mat_desc not in", values, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescBetween(String value1, String value2) {
            addCriterion("ity_mat_desc between", value1, value2, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyMatDescNotBetween(String value1, String value2) {
            addCriterion("ity_mat_desc not between", value1, value2, "ityMatDesc");
            return (Criteria) this;
        }

        public Criteria andItyProCodeIsNull() {
            addCriterion("ity_pro_code is null");
            return (Criteria) this;
        }

        public Criteria andItyProCodeIsNotNull() {
            addCriterion("ity_pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyProCodeEqualTo(String value) {
            addCriterion("ity_pro_code =", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotEqualTo(String value) {
            addCriterion("ity_pro_code <>", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeGreaterThan(String value) {
            addCriterion("ity_pro_code >", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_pro_code >=", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeLessThan(String value) {
            addCriterion("ity_pro_code <", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_pro_code <=", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeLike(String value) {
            addCriterion("ity_pro_code like", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotLike(String value) {
            addCriterion("ity_pro_code not like", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeIn(List<String> values) {
            addCriterion("ity_pro_code in", values, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotIn(List<String> values) {
            addCriterion("ity_pro_code not in", values, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeBetween(String value1, String value2) {
            addCriterion("ity_pro_code between", value1, value2, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotBetween(String value1, String value2) {
            addCriterion("ity_pro_code not between", value1, value2, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProNameIsNull() {
            addCriterion("ity_pro_name is null");
            return (Criteria) this;
        }

        public Criteria andItyProNameIsNotNull() {
            addCriterion("ity_pro_name is not null");
            return (Criteria) this;
        }

        public Criteria andItyProNameEqualTo(String value) {
            addCriterion("ity_pro_name =", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotEqualTo(String value) {
            addCriterion("ity_pro_name <>", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameGreaterThan(String value) {
            addCriterion("ity_pro_name >", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameGreaterThanOrEqualTo(String value) {
            addCriterion("ity_pro_name >=", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameLessThan(String value) {
            addCriterion("ity_pro_name <", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameLessThanOrEqualTo(String value) {
            addCriterion("ity_pro_name <=", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameLike(String value) {
            addCriterion("ity_pro_name like", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotLike(String value) {
            addCriterion("ity_pro_name not like", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameIn(List<String> values) {
            addCriterion("ity_pro_name in", values, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotIn(List<String> values) {
            addCriterion("ity_pro_name not in", values, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameBetween(String value1, String value2) {
            addCriterion("ity_pro_name between", value1, value2, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotBetween(String value1, String value2) {
            addCriterion("ity_pro_name not between", value1, value2, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyPartIsNull() {
            addCriterion("ity_part is null");
            return (Criteria) this;
        }

        public Criteria andItyPartIsNotNull() {
            addCriterion("ity_part is not null");
            return (Criteria) this;
        }

        public Criteria andItyPartEqualTo(String value) {
            addCriterion("ity_part =", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartNotEqualTo(String value) {
            addCriterion("ity_part <>", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartGreaterThan(String value) {
            addCriterion("ity_part >", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartGreaterThanOrEqualTo(String value) {
            addCriterion("ity_part >=", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartLessThan(String value) {
            addCriterion("ity_part <", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartLessThanOrEqualTo(String value) {
            addCriterion("ity_part <=", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartLike(String value) {
            addCriterion("ity_part like", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartNotLike(String value) {
            addCriterion("ity_part not like", value, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartIn(List<String> values) {
            addCriterion("ity_part in", values, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartNotIn(List<String> values) {
            addCriterion("ity_part not in", values, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartBetween(String value1, String value2) {
            addCriterion("ity_part between", value1, value2, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyPartNotBetween(String value1, String value2) {
            addCriterion("ity_part not between", value1, value2, "ityPart");
            return (Criteria) this;
        }

        public Criteria andItyNumIsNull() {
            addCriterion("ity_num is null");
            return (Criteria) this;
        }

        public Criteria andItyNumIsNotNull() {
            addCriterion("ity_num is not null");
            return (Criteria) this;
        }

        public Criteria andItyNumEqualTo(Double value) {
            addCriterion("ity_num =", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumNotEqualTo(Double value) {
            addCriterion("ity_num <>", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumGreaterThan(Double value) {
            addCriterion("ity_num >", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_num >=", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumLessThan(Double value) {
            addCriterion("ity_num <", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumLessThanOrEqualTo(Double value) {
            addCriterion("ity_num <=", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumIn(List<Double> values) {
            addCriterion("ity_num in", values, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumNotIn(List<Double> values) {
            addCriterion("ity_num not in", values, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumBetween(Double value1, Double value2) {
            addCriterion("ity_num between", value1, value2, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumNotBetween(Double value1, Double value2) {
            addCriterion("ity_num not between", value1, value2, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyWeightIsNull() {
            addCriterion("ity_weight is null");
            return (Criteria) this;
        }

        public Criteria andItyWeightIsNotNull() {
            addCriterion("ity_weight is not null");
            return (Criteria) this;
        }

        public Criteria andItyWeightEqualTo(Double value) {
            addCriterion("ity_weight =", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightNotEqualTo(Double value) {
            addCriterion("ity_weight <>", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightGreaterThan(Double value) {
            addCriterion("ity_weight >", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_weight >=", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightLessThan(Double value) {
            addCriterion("ity_weight <", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightLessThanOrEqualTo(Double value) {
            addCriterion("ity_weight <=", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightIn(List<Double> values) {
            addCriterion("ity_weight in", values, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightNotIn(List<Double> values) {
            addCriterion("ity_weight not in", values, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightBetween(Double value1, Double value2) {
            addCriterion("ity_weight between", value1, value2, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightNotBetween(Double value1, Double value2) {
            addCriterion("ity_weight not between", value1, value2, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumIsNull() {
            addCriterion("ity_ava_num is null");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumIsNotNull() {
            addCriterion("ity_ava_num is not null");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumEqualTo(Double value) {
            addCriterion("ity_ava_num =", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumNotEqualTo(Double value) {
            addCriterion("ity_ava_num <>", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumGreaterThan(Double value) {
            addCriterion("ity_ava_num >", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_ava_num >=", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumLessThan(Double value) {
            addCriterion("ity_ava_num <", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumLessThanOrEqualTo(Double value) {
            addCriterion("ity_ava_num <=", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumIn(List<Double> values) {
            addCriterion("ity_ava_num in", values, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumNotIn(List<Double> values) {
            addCriterion("ity_ava_num not in", values, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumBetween(Double value1, Double value2) {
            addCriterion("ity_ava_num between", value1, value2, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumNotBetween(Double value1, Double value2) {
            addCriterion("ity_ava_num not between", value1, value2, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightIsNull() {
            addCriterion("ity_ava_weight is null");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightIsNotNull() {
            addCriterion("ity_ava_weight is not null");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightEqualTo(Double value) {
            addCriterion("ity_ava_weight =", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightNotEqualTo(Double value) {
            addCriterion("ity_ava_weight <>", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightGreaterThan(Double value) {
            addCriterion("ity_ava_weight >", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_ava_weight >=", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightLessThan(Double value) {
            addCriterion("ity_ava_weight <", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightLessThanOrEqualTo(Double value) {
            addCriterion("ity_ava_weight <=", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightIn(List<Double> values) {
            addCriterion("ity_ava_weight in", values, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightNotIn(List<Double> values) {
            addCriterion("ity_ava_weight not in", values, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightBetween(Double value1, Double value2) {
            addCriterion("ity_ava_weight between", value1, value2, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightNotBetween(Double value1, Double value2) {
            addCriterion("ity_ava_weight not between", value1, value2, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitIsNull() {
            addCriterion("ity_num_unit is null");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitIsNotNull() {
            addCriterion("ity_num_unit is not null");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitEqualTo(String value) {
            addCriterion("ity_num_unit =", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitNotEqualTo(String value) {
            addCriterion("ity_num_unit <>", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitGreaterThan(String value) {
            addCriterion("ity_num_unit >", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitGreaterThanOrEqualTo(String value) {
            addCriterion("ity_num_unit >=", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitLessThan(String value) {
            addCriterion("ity_num_unit <", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitLessThanOrEqualTo(String value) {
            addCriterion("ity_num_unit <=", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitLike(String value) {
            addCriterion("ity_num_unit like", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitNotLike(String value) {
            addCriterion("ity_num_unit not like", value, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitIn(List<String> values) {
            addCriterion("ity_num_unit in", values, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitNotIn(List<String> values) {
            addCriterion("ity_num_unit not in", values, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitBetween(String value1, String value2) {
            addCriterion("ity_num_unit between", value1, value2, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyNumUnitNotBetween(String value1, String value2) {
            addCriterion("ity_num_unit not between", value1, value2, "ityNumUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitIsNull() {
            addCriterion("ity_weight_unit is null");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitIsNotNull() {
            addCriterion("ity_weight_unit is not null");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitEqualTo(String value) {
            addCriterion("ity_weight_unit =", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitNotEqualTo(String value) {
            addCriterion("ity_weight_unit <>", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitGreaterThan(String value) {
            addCriterion("ity_weight_unit >", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitGreaterThanOrEqualTo(String value) {
            addCriterion("ity_weight_unit >=", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitLessThan(String value) {
            addCriterion("ity_weight_unit <", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitLessThanOrEqualTo(String value) {
            addCriterion("ity_weight_unit <=", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitLike(String value) {
            addCriterion("ity_weight_unit like", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitNotLike(String value) {
            addCriterion("ity_weight_unit not like", value, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitIn(List<String> values) {
            addCriterion("ity_weight_unit in", values, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitNotIn(List<String> values) {
            addCriterion("ity_weight_unit not in", values, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitBetween(String value1, String value2) {
            addCriterion("ity_weight_unit between", value1, value2, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyWeightUnitNotBetween(String value1, String value2) {
            addCriterion("ity_weight_unit not between", value1, value2, "ityWeightUnit");
            return (Criteria) this;
        }

        public Criteria andItyPriceIsNull() {
            addCriterion("ity_price is null");
            return (Criteria) this;
        }

        public Criteria andItyPriceIsNotNull() {
            addCriterion("ity_price is not null");
            return (Criteria) this;
        }

        public Criteria andItyPriceEqualTo(Double value) {
            addCriterion("ity_price =", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceNotEqualTo(Double value) {
            addCriterion("ity_price <>", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceGreaterThan(Double value) {
            addCriterion("ity_price >", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_price >=", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceLessThan(Double value) {
            addCriterion("ity_price <", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceLessThanOrEqualTo(Double value) {
            addCriterion("ity_price <=", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceIn(List<Double> values) {
            addCriterion("ity_price in", values, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceNotIn(List<Double> values) {
            addCriterion("ity_price not in", values, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceBetween(Double value1, Double value2) {
            addCriterion("ity_price between", value1, value2, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceNotBetween(Double value1, Double value2) {
            addCriterion("ity_price not between", value1, value2, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyAmountIsNull() {
            addCriterion("ity_amount is null");
            return (Criteria) this;
        }

        public Criteria andItyAmountIsNotNull() {
            addCriterion("ity_amount is not null");
            return (Criteria) this;
        }

        public Criteria andItyAmountEqualTo(BigDecimal value) {
            addCriterion("ity_amount =", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountNotEqualTo(BigDecimal value) {
            addCriterion("ity_amount <>", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountGreaterThan(BigDecimal value) {
            addCriterion("ity_amount >", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ity_amount >=", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountLessThan(BigDecimal value) {
            addCriterion("ity_amount <", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ity_amount <=", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountIn(List<BigDecimal> values) {
            addCriterion("ity_amount in", values, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountNotIn(List<BigDecimal> values) {
            addCriterion("ity_amount not in", values, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ity_amount between", value1, value2, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ity_amount not between", value1, value2, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyBrandIsNull() {
            addCriterion("ity_brand is null");
            return (Criteria) this;
        }

        public Criteria andItyBrandIsNotNull() {
            addCriterion("ity_brand is not null");
            return (Criteria) this;
        }

        public Criteria andItyBrandEqualTo(String value) {
            addCriterion("ity_brand =", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandNotEqualTo(String value) {
            addCriterion("ity_brand <>", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandGreaterThan(String value) {
            addCriterion("ity_brand >", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandGreaterThanOrEqualTo(String value) {
            addCriterion("ity_brand >=", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandLessThan(String value) {
            addCriterion("ity_brand <", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandLessThanOrEqualTo(String value) {
            addCriterion("ity_brand <=", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandLike(String value) {
            addCriterion("ity_brand like", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandNotLike(String value) {
            addCriterion("ity_brand not like", value, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandIn(List<String> values) {
            addCriterion("ity_brand in", values, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandNotIn(List<String> values) {
            addCriterion("ity_brand not in", values, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandBetween(String value1, String value2) {
            addCriterion("ity_brand between", value1, value2, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItyBrandNotBetween(String value1, String value2) {
            addCriterion("ity_brand not between", value1, value2, "ityBrand");
            return (Criteria) this;
        }

        public Criteria andItySatIsNull() {
            addCriterion("ity_sat is null");
            return (Criteria) this;
        }

        public Criteria andItySatIsNotNull() {
            addCriterion("ity_sat is not null");
            return (Criteria) this;
        }

        public Criteria andItySatEqualTo(String value) {
            addCriterion("ity_sat =", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatNotEqualTo(String value) {
            addCriterion("ity_sat <>", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatGreaterThan(String value) {
            addCriterion("ity_sat >", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatGreaterThanOrEqualTo(String value) {
            addCriterion("ity_sat >=", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatLessThan(String value) {
            addCriterion("ity_sat <", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatLessThanOrEqualTo(String value) {
            addCriterion("ity_sat <=", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatLike(String value) {
            addCriterion("ity_sat like", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatNotLike(String value) {
            addCriterion("ity_sat not like", value, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatIn(List<String> values) {
            addCriterion("ity_sat in", values, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatNotIn(List<String> values) {
            addCriterion("ity_sat not in", values, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatBetween(String value1, String value2) {
            addCriterion("ity_sat between", value1, value2, "itySat");
            return (Criteria) this;
        }

        public Criteria andItySatNotBetween(String value1, String value2) {
            addCriterion("ity_sat not between", value1, value2, "itySat");
            return (Criteria) this;
        }

        public Criteria andItyPositionIsNull() {
            addCriterion("ity_position is null");
            return (Criteria) this;
        }

        public Criteria andItyPositionIsNotNull() {
            addCriterion("ity_position is not null");
            return (Criteria) this;
        }

        public Criteria andItyPositionEqualTo(String value) {
            addCriterion("ity_position =", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionNotEqualTo(String value) {
            addCriterion("ity_position <>", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionGreaterThan(String value) {
            addCriterion("ity_position >", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionGreaterThanOrEqualTo(String value) {
            addCriterion("ity_position >=", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionLessThan(String value) {
            addCriterion("ity_position <", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionLessThanOrEqualTo(String value) {
            addCriterion("ity_position <=", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionLike(String value) {
            addCriterion("ity_position like", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionNotLike(String value) {
            addCriterion("ity_position not like", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionIn(List<String> values) {
            addCriterion("ity_position in", values, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionNotIn(List<String> values) {
            addCriterion("ity_position not in", values, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionBetween(String value1, String value2) {
            addCriterion("ity_position between", value1, value2, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyPositionNotBetween(String value1, String value2) {
            addCriterion("ity_position not between", value1, value2, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdIsNull() {
            addCriterion("ity_whi_id is null");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdIsNotNull() {
            addCriterion("ity_whi_id is not null");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdEqualTo(Integer value) {
            addCriterion("ity_whi_id =", value, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdNotEqualTo(Integer value) {
            addCriterion("ity_whi_id <>", value, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdGreaterThan(Integer value) {
            addCriterion("ity_whi_id >", value, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_whi_id >=", value, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdLessThan(Integer value) {
            addCriterion("ity_whi_id <", value, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdLessThanOrEqualTo(Integer value) {
            addCriterion("ity_whi_id <=", value, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdIn(List<Integer> values) {
            addCriterion("ity_whi_id in", values, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdNotIn(List<Integer> values) {
            addCriterion("ity_whi_id not in", values, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdBetween(Integer value1, Integer value2) {
            addCriterion("ity_whi_id between", value1, value2, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItyWhiIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_whi_id not between", value1, value2, "ityWhiId");
            return (Criteria) this;
        }

        public Criteria andItySapCodeIsNull() {
            addCriterion("ity_sap_code is null");
            return (Criteria) this;
        }

        public Criteria andItySapCodeIsNotNull() {
            addCriterion("ity_sap_code is not null");
            return (Criteria) this;
        }

        public Criteria andItySapCodeEqualTo(String value) {
            addCriterion("ity_sap_code =", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeNotEqualTo(String value) {
            addCriterion("ity_sap_code <>", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeGreaterThan(String value) {
            addCriterion("ity_sap_code >", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_sap_code >=", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeLessThan(String value) {
            addCriterion("ity_sap_code <", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_sap_code <=", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeLike(String value) {
            addCriterion("ity_sap_code like", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeNotLike(String value) {
            addCriterion("ity_sap_code not like", value, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeIn(List<String> values) {
            addCriterion("ity_sap_code in", values, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeNotIn(List<String> values) {
            addCriterion("ity_sap_code not in", values, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeBetween(String value1, String value2) {
            addCriterion("ity_sap_code between", value1, value2, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItySapCodeNotBetween(String value1, String value2) {
            addCriterion("ity_sap_code not between", value1, value2, "itySapCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeIsNull() {
            addCriterion("ity_track_code is null");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeIsNotNull() {
            addCriterion("ity_track_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeEqualTo(String value) {
            addCriterion("ity_track_code =", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotEqualTo(String value) {
            addCriterion("ity_track_code <>", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeGreaterThan(String value) {
            addCriterion("ity_track_code >", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_track_code >=", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeLessThan(String value) {
            addCriterion("ity_track_code <", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_track_code <=", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeLike(String value) {
            addCriterion("ity_track_code like", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotLike(String value) {
            addCriterion("ity_track_code not like", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeIn(List<String> values) {
            addCriterion("ity_track_code in", values, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotIn(List<String> values) {
            addCriterion("ity_track_code not in", values, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeBetween(String value1, String value2) {
            addCriterion("ity_track_code between", value1, value2, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotBetween(String value1, String value2) {
            addCriterion("ity_track_code not between", value1, value2, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyRemarkIsNull() {
            addCriterion("ity_remark is null");
            return (Criteria) this;
        }

        public Criteria andItyRemarkIsNotNull() {
            addCriterion("ity_remark is not null");
            return (Criteria) this;
        }

        public Criteria andItyRemarkEqualTo(String value) {
            addCriterion("ity_remark =", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotEqualTo(String value) {
            addCriterion("ity_remark <>", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkGreaterThan(String value) {
            addCriterion("ity_remark >", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("ity_remark >=", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkLessThan(String value) {
            addCriterion("ity_remark <", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkLessThanOrEqualTo(String value) {
            addCriterion("ity_remark <=", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkLike(String value) {
            addCriterion("ity_remark like", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotLike(String value) {
            addCriterion("ity_remark not like", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkIn(List<String> values) {
            addCriterion("ity_remark in", values, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotIn(List<String> values) {
            addCriterion("ity_remark not in", values, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkBetween(String value1, String value2) {
            addCriterion("ity_remark between", value1, value2, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotBetween(String value1, String value2) {
            addCriterion("ity_remark not between", value1, value2, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateIsNull() {
            addCriterion("ity_bookkeeping_date is null");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateIsNotNull() {
            addCriterion("ity_bookkeeping_date is not null");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateEqualTo(Date value) {
            addCriterion("ity_bookkeeping_date =", value, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateNotEqualTo(Date value) {
            addCriterion("ity_bookkeeping_date <>", value, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateGreaterThan(Date value) {
            addCriterion("ity_bookkeeping_date >", value, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ity_bookkeeping_date >=", value, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateLessThan(Date value) {
            addCriterion("ity_bookkeeping_date <", value, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateLessThanOrEqualTo(Date value) {
            addCriterion("ity_bookkeeping_date <=", value, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateIn(List<Date> values) {
            addCriterion("ity_bookkeeping_date in", values, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateNotIn(List<Date> values) {
            addCriterion("ity_bookkeeping_date not in", values, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateBetween(Date value1, Date value2) {
            addCriterion("ity_bookkeeping_date between", value1, value2, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyBookkeepingDateNotBetween(Date value1, Date value2) {
            addCriterion("ity_bookkeeping_date not between", value1, value2, "ityBookkeepingDate");
            return (Criteria) this;
        }

        public Criteria andItyRowNoIsNull() {
            addCriterion("ity_row_no is null");
            return (Criteria) this;
        }

        public Criteria andItyRowNoIsNotNull() {
            addCriterion("ity_row_no is not null");
            return (Criteria) this;
        }

        public Criteria andItyRowNoEqualTo(Integer value) {
            addCriterion("ity_row_no =", value, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoNotEqualTo(Integer value) {
            addCriterion("ity_row_no <>", value, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoGreaterThan(Integer value) {
            addCriterion("ity_row_no >", value, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_row_no >=", value, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoLessThan(Integer value) {
            addCriterion("ity_row_no <", value, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoLessThanOrEqualTo(Integer value) {
            addCriterion("ity_row_no <=", value, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoIn(List<Integer> values) {
            addCriterion("ity_row_no in", values, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoNotIn(List<Integer> values) {
            addCriterion("ity_row_no not in", values, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoBetween(Integer value1, Integer value2) {
            addCriterion("ity_row_no between", value1, value2, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyRowNoNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_row_no not between", value1, value2, "ityRowNo");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeIsNull() {
            addCriterion("ity_stock_type is null");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeIsNotNull() {
            addCriterion("ity_stock_type is not null");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeEqualTo(Integer value) {
            addCriterion("ity_stock_type =", value, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeNotEqualTo(Integer value) {
            addCriterion("ity_stock_type <>", value, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeGreaterThan(Integer value) {
            addCriterion("ity_stock_type >", value, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_stock_type >=", value, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeLessThan(Integer value) {
            addCriterion("ity_stock_type <", value, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeLessThanOrEqualTo(Integer value) {
            addCriterion("ity_stock_type <=", value, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeIn(List<Integer> values) {
            addCriterion("ity_stock_type in", values, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeNotIn(List<Integer> values) {
            addCriterion("ity_stock_type not in", values, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeBetween(Integer value1, Integer value2) {
            addCriterion("ity_stock_type between", value1, value2, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStockTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_stock_type not between", value1, value2, "ityStockType");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateIsNull() {
            addCriterion("ity_storage_date is null");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateIsNotNull() {
            addCriterion("ity_storage_date is not null");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateEqualTo(Date value) {
            addCriterionForJDBCDate("ity_storage_date =", value, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("ity_storage_date <>", value, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateGreaterThan(Date value) {
            addCriterionForJDBCDate("ity_storage_date >", value, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("ity_storage_date >=", value, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateLessThan(Date value) {
            addCriterionForJDBCDate("ity_storage_date <", value, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("ity_storage_date <=", value, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateIn(List<Date> values) {
            addCriterionForJDBCDate("ity_storage_date in", values, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("ity_storage_date not in", values, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("ity_storage_date between", value1, value2, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyStorageDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("ity_storage_date not between", value1, value2, "ityStorageDate");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagIsNull() {
            addCriterion("ity_change_flag is null");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagIsNotNull() {
            addCriterion("ity_change_flag is not null");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagEqualTo(Integer value) {
            addCriterion("ity_change_flag =", value, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagNotEqualTo(Integer value) {
            addCriterion("ity_change_flag <>", value, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagGreaterThan(Integer value) {
            addCriterion("ity_change_flag >", value, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_change_flag >=", value, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagLessThan(Integer value) {
            addCriterion("ity_change_flag <", value, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagLessThanOrEqualTo(Integer value) {
            addCriterion("ity_change_flag <=", value, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagIn(List<Integer> values) {
            addCriterion("ity_change_flag in", values, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagNotIn(List<Integer> values) {
            addCriterion("ity_change_flag not in", values, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagBetween(Integer value1, Integer value2) {
            addCriterion("ity_change_flag between", value1, value2, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyChangeFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_change_flag not between", value1, value2, "ityChangeFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagIsNull() {
            addCriterion("ity_inv_pro_flag is null");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagIsNotNull() {
            addCriterion("ity_inv_pro_flag is not null");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagEqualTo(Integer value) {
            addCriterion("ity_inv_pro_flag =", value, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagNotEqualTo(Integer value) {
            addCriterion("ity_inv_pro_flag <>", value, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagGreaterThan(Integer value) {
            addCriterion("ity_inv_pro_flag >", value, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_inv_pro_flag >=", value, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagLessThan(Integer value) {
            addCriterion("ity_inv_pro_flag <", value, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagLessThanOrEqualTo(Integer value) {
            addCriterion("ity_inv_pro_flag <=", value, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagIn(List<Integer> values) {
            addCriterion("ity_inv_pro_flag in", values, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagNotIn(List<Integer> values) {
            addCriterion("ity_inv_pro_flag not in", values, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagBetween(Integer value1, Integer value2) {
            addCriterion("ity_inv_pro_flag between", value1, value2, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyInvProFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_inv_pro_flag not between", value1, value2, "ityInvProFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagIsNull() {
            addCriterion("ity_adjust_flag is null");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagIsNotNull() {
            addCriterion("ity_adjust_flag is not null");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagEqualTo(Integer value) {
            addCriterion("ity_adjust_flag =", value, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagNotEqualTo(Integer value) {
            addCriterion("ity_adjust_flag <>", value, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagGreaterThan(Integer value) {
            addCriterion("ity_adjust_flag >", value, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_adjust_flag >=", value, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagLessThan(Integer value) {
            addCriterion("ity_adjust_flag <", value, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagLessThanOrEqualTo(Integer value) {
            addCriterion("ity_adjust_flag <=", value, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagIn(List<Integer> values) {
            addCriterion("ity_adjust_flag in", values, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagNotIn(List<Integer> values) {
            addCriterion("ity_adjust_flag not in", values, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagBetween(Integer value1, Integer value2) {
            addCriterion("ity_adjust_flag between", value1, value2, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyAdjustFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_adjust_flag not between", value1, value2, "ityAdjustFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagIsNull() {
            addCriterion("ity_pro_inv_flag is null");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagIsNotNull() {
            addCriterion("ity_pro_inv_flag is not null");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagEqualTo(Integer value) {
            addCriterion("ity_pro_inv_flag =", value, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagNotEqualTo(Integer value) {
            addCriterion("ity_pro_inv_flag <>", value, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagGreaterThan(Integer value) {
            addCriterion("ity_pro_inv_flag >", value, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_pro_inv_flag >=", value, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagLessThan(Integer value) {
            addCriterion("ity_pro_inv_flag <", value, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagLessThanOrEqualTo(Integer value) {
            addCriterion("ity_pro_inv_flag <=", value, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagIn(List<Integer> values) {
            addCriterion("ity_pro_inv_flag in", values, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagNotIn(List<Integer> values) {
            addCriterion("ity_pro_inv_flag not in", values, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagBetween(Integer value1, Integer value2) {
            addCriterion("ity_pro_inv_flag between", value1, value2, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyProInvFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_pro_inv_flag not between", value1, value2, "ityProInvFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagIsNull() {
            addCriterion("ity_materiel_info_flag is null");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagIsNotNull() {
            addCriterion("ity_materiel_info_flag is not null");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagEqualTo(Integer value) {
            addCriterion("ity_materiel_info_flag =", value, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagNotEqualTo(Integer value) {
            addCriterion("ity_materiel_info_flag <>", value, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagGreaterThan(Integer value) {
            addCriterion("ity_materiel_info_flag >", value, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_materiel_info_flag >=", value, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagLessThan(Integer value) {
            addCriterion("ity_materiel_info_flag <", value, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagLessThanOrEqualTo(Integer value) {
            addCriterion("ity_materiel_info_flag <=", value, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagIn(List<Integer> values) {
            addCriterion("ity_materiel_info_flag in", values, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagNotIn(List<Integer> values) {
            addCriterion("ity_materiel_info_flag not in", values, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagBetween(Integer value1, Integer value2) {
            addCriterion("ity_materiel_info_flag between", value1, value2, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyMaterielInfoFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_materiel_info_flag not between", value1, value2, "ityMaterielInfoFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagIsNull() {
            addCriterion("ity_annex_flag is null");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagIsNotNull() {
            addCriterion("ity_annex_flag is not null");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagEqualTo(Integer value) {
            addCriterion("ity_annex_flag =", value, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagNotEqualTo(Integer value) {
            addCriterion("ity_annex_flag <>", value, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagGreaterThan(Integer value) {
            addCriterion("ity_annex_flag >", value, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_annex_flag >=", value, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagLessThan(Integer value) {
            addCriterion("ity_annex_flag <", value, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagLessThanOrEqualTo(Integer value) {
            addCriterion("ity_annex_flag <=", value, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagIn(List<Integer> values) {
            addCriterion("ity_annex_flag in", values, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagNotIn(List<Integer> values) {
            addCriterion("ity_annex_flag not in", values, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagBetween(Integer value1, Integer value2) {
            addCriterion("ity_annex_flag between", value1, value2, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAnnexFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_annex_flag not between", value1, value2, "ityAnnexFlag");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeIsNull() {
            addCriterion("ity_ancestors_pro_code is null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeIsNotNull() {
            addCriterion("ity_ancestors_pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeEqualTo(String value) {
            addCriterion("ity_ancestors_pro_code =", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeNotEqualTo(String value) {
            addCriterion("ity_ancestors_pro_code <>", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeGreaterThan(String value) {
            addCriterion("ity_ancestors_pro_code >", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_ancestors_pro_code >=", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeLessThan(String value) {
            addCriterion("ity_ancestors_pro_code <", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_ancestors_pro_code <=", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeLike(String value) {
            addCriterion("ity_ancestors_pro_code like", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeNotLike(String value) {
            addCriterion("ity_ancestors_pro_code not like", value, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeIn(List<String> values) {
            addCriterion("ity_ancestors_pro_code in", values, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeNotIn(List<String> values) {
            addCriterion("ity_ancestors_pro_code not in", values, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeBetween(String value1, String value2) {
            addCriterion("ity_ancestors_pro_code between", value1, value2, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsProCodeNotBetween(String value1, String value2) {
            addCriterion("ity_ancestors_pro_code not between", value1, value2, "ityAncestorsProCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeIsNull() {
            addCriterion("ity_ancestors_track_code is null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeIsNotNull() {
            addCriterion("ity_ancestors_track_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeEqualTo(String value) {
            addCriterion("ity_ancestors_track_code =", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeNotEqualTo(String value) {
            addCriterion("ity_ancestors_track_code <>", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeGreaterThan(String value) {
            addCriterion("ity_ancestors_track_code >", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_ancestors_track_code >=", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeLessThan(String value) {
            addCriterion("ity_ancestors_track_code <", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_ancestors_track_code <=", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeLike(String value) {
            addCriterion("ity_ancestors_track_code like", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeNotLike(String value) {
            addCriterion("ity_ancestors_track_code not like", value, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeIn(List<String> values) {
            addCriterion("ity_ancestors_track_code in", values, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeNotIn(List<String> values) {
            addCriterion("ity_ancestors_track_code not in", values, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeBetween(String value1, String value2) {
            addCriterion("ity_ancestors_track_code between", value1, value2, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsTrackCodeNotBetween(String value1, String value2) {
            addCriterion("ity_ancestors_track_code not between", value1, value2, "ityAncestorsTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumIsNull() {
            addCriterion("ity_ancestors_num is null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumIsNotNull() {
            addCriterion("ity_ancestors_num is not null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumEqualTo(Double value) {
            addCriterion("ity_ancestors_num =", value, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumNotEqualTo(Double value) {
            addCriterion("ity_ancestors_num <>", value, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumGreaterThan(Double value) {
            addCriterion("ity_ancestors_num >", value, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_ancestors_num >=", value, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumLessThan(Double value) {
            addCriterion("ity_ancestors_num <", value, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumLessThanOrEqualTo(Double value) {
            addCriterion("ity_ancestors_num <=", value, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumIn(List<Double> values) {
            addCriterion("ity_ancestors_num in", values, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumNotIn(List<Double> values) {
            addCriterion("ity_ancestors_num not in", values, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumBetween(Double value1, Double value2) {
            addCriterion("ity_ancestors_num between", value1, value2, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsNumNotBetween(Double value1, Double value2) {
            addCriterion("ity_ancestors_num not between", value1, value2, "ityAncestorsNum");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelIsNull() {
            addCriterion("ity_ancestors_level is null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelIsNotNull() {
            addCriterion("ity_ancestors_level is not null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelEqualTo(Integer value) {
            addCriterion("ity_ancestors_level =", value, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelNotEqualTo(Integer value) {
            addCriterion("ity_ancestors_level <>", value, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelGreaterThan(Integer value) {
            addCriterion("ity_ancestors_level >", value, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_ancestors_level >=", value, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelLessThan(Integer value) {
            addCriterion("ity_ancestors_level <", value, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelLessThanOrEqualTo(Integer value) {
            addCriterion("ity_ancestors_level <=", value, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelIn(List<Integer> values) {
            addCriterion("ity_ancestors_level in", values, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelNotIn(List<Integer> values) {
            addCriterion("ity_ancestors_level not in", values, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelBetween(Integer value1, Integer value2) {
            addCriterion("ity_ancestors_level between", value1, value2, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_ancestors_level not between", value1, value2, "ityAncestorsLevel");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityIsNull() {
            addCriterion("ity_ancestors_identity is null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityIsNotNull() {
            addCriterion("ity_ancestors_identity is not null");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityEqualTo(String value) {
            addCriterion("ity_ancestors_identity =", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityNotEqualTo(String value) {
            addCriterion("ity_ancestors_identity <>", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityGreaterThan(String value) {
            addCriterion("ity_ancestors_identity >", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityGreaterThanOrEqualTo(String value) {
            addCriterion("ity_ancestors_identity >=", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityLessThan(String value) {
            addCriterion("ity_ancestors_identity <", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityLessThanOrEqualTo(String value) {
            addCriterion("ity_ancestors_identity <=", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityLike(String value) {
            addCriterion("ity_ancestors_identity like", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityNotLike(String value) {
            addCriterion("ity_ancestors_identity not like", value, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityIn(List<String> values) {
            addCriterion("ity_ancestors_identity in", values, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityNotIn(List<String> values) {
            addCriterion("ity_ancestors_identity not in", values, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityBetween(String value1, String value2) {
            addCriterion("ity_ancestors_identity between", value1, value2, "ityAncestorsIdentity");
            return (Criteria) this;
        }

        public Criteria andItyAncestorsIdentityNotBetween(String value1, String value2) {
            addCriterion("ity_ancestors_identity not between", value1, value2, "ityAncestorsIdentity");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}